SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Views!! A must-see contemporary home with 4 bedrooms, 3 full baths and many upgrades throughout the years. Enjoy the privacy of 12 acres at the end of the street. Step into a large tiled foyer and turn to see a glorious living area with a cathedral ceiling, beautiful 2-story stone fireplace and bookended with floor-to-ceiling windows for spectacular views and an abundance of natural light. A large deck off the back overlooks the wide open pasture and a second deck off the bedrooms on the upper level takes advantage of the views. A huge gourmet kitchen features stainless steel appliances, a breakfast bar, large prep island with additional sink, and counter space and cabinets galore. The open dining area adjacent to the kitchen and living area allows for easy entertaining. A large family room on the main level boasts an entire wall of built-ins. Convenient 1st floor laundry room with even more storage. And you don’t want to miss seeing the spa-like bathroom with a double vanity, soaking tub and separate steam shower. Outside features a 5-car garage and your very own tennis court!
Description:2 WOODS END ROAD- Well maintained 3-bed & 4-bath contemporary sited on 3 landscaped acres conveniently located just 10 minutes from downtown Hanover. A spacious and updated kitchen flows effortlessly into an open concept living & dining area with fireplace and wood stove and an expansive outdoor deck and gazebo, all of which bathes in natural light to make it a perfect setup for entertaining family and friends. On the front side of the house is another sizable living or family area, office space that is a ground floor bedroom option, and 3/4 bath. The second floor features a warm and sunlit primary suite, two additional bedrooms, and a full bath. A finished lower level complete with full bath and two versatile recreation / bonus rooms offers plenty of overflow space. Renovated mudroom on main level is dog kennel option. With easy access to area schools, recreation, restaurants, shopping, and more, this turnkey Hanover home is a must-see. Most of furnished photos are virtually staged.